﻿CREATE TABLE tHolidays
    (
      holidayId INT NOT NULL
                    CONSTRAINT [pk_tHolidays_holidayId] PRIMARY KEY ,
      holidayName VARCHAR(200) NOT NULL ,
      [description] VARCHAR(500) NULL ,
      holidayMonth INT NOT NULL ,
      holidayDate INT NOT NULL ,
      holidayTypeId INT
        NOT NULL
        CONSTRAINT [fk_tHolidays_holidayTypeId]
        FOREIGN KEY ( holidayTypeId ) REFERENCES dbo.tHolidayType ( [holidayTypeId] ) ,
      countryId INT
        NOT NULL
        CONSTRAINT [fk_tHolidays_countryId]
        FOREIGN KEY ( countryId ) REFERENCES dbo.tCountry ( [CountryID] )
    )